﻿using System;
using System.Collections.Generic;
using System.Drawing;
using System.Data;
using System.Windows.Forms;
using FarPoint.Win.Spread;
using GrapeCity.Spreadsheet;
using GrapeCity.Spreadsheet.Slicers;
using GrapeCity.Spreadsheet.Drawing;
using FarPoint.Win.Spread.Data;
using Spread.Common.DataStore;

namespace Spread.Slicers.Features
{
  public partial class Introduction : Spread.Common.Features.Sample.BaseSampleControl
  {
    public Introduction()
    {
      InitializeComponent();
      InitStylesMenuItems();

      var dataSource = new DataService().AccessDataSource;
      var dataTable = dataSource.GetNWINDData("Suppliers").Tables[0];

      //Reduce table size for fit layout
      if (dataTable.Rows.Count > 10)
      {
        while (dataTable.Rows.Count > 10)
        {
          dataTable.Rows.RemoveAt(dataTable.Rows.Count - 1);
        }
        dataTable.AcceptChanges();
      }

      SpreadDataBindingAdapter adapter = new SpreadDataBindingAdapter();
      adapter.Spread = fpSpread1;
      adapter.SheetName = "Sheet1";
      adapter.DataSource = dataTable;
      adapter.MapperInfo = new MapperInfo(1, 0, 30, dataTable.Columns.Count);
      adapter.FillSpreadDataByDataSource();

      //code for table
      float size;
      int col = 0;
      foreach (DataColumn column in dataTable.Columns)
      {
        fpSpread1.Sheets[0].Cells[0, col].Text = (column.Caption);
        size = fpSpread1.Sheets[0].Columns[col].GetPreferredWidth();
        fpSpread1.Sheets[0].Columns[col].Width = size;
        col++;
      }


      fpSpread1.Features.RichClipboard = true;
      fpSpread1.Features.EnhancedShapeEngine = true;
      fpSpread1.Features.EnhancedShapeEngine = true;
      IWorkbook workbook = fpSpread1.AsWorkbook();

      IWorksheet worksheet = workbook.Worksheets[0];

      ITable table = worksheet.Range("A1:L11").CreateTable(true);

      ISlicerCache cache = workbook.SlicerCaches.Add(table, 8, "Country");
      ISlicer slicer = cache.Slicers.Add(worksheet, "Country", "Country", 100, 220, 250, 200);

      fpSpread1.ActiveSheet.Columns[6].Visible = false;
      fpSpread1.ActiveSheet.Columns[10, 11].Visible = false;


      // apply built-in style "Dark5"
      slicer.Style = workbook.TableStyles[BuiltInSlicerStyles.SlicerStyleDark5];
      // make that menu item appear "checked"
      ToolStripMenuItem item = (ToolStripMenuItem)styleToolStripMenuItem.DropDownItems[12];//["Dark5"];
      item.Checked = true;

      // activate the worksheet and select the slicer shape
      worksheet.Activate();
      //worksheet.Shapes[0].Select();
      worksheet.Slicers[0].Shape.Select();
      workbook.WorkbookSet.UIManager.ShapeChanged += UIManager_ShapeChanged;
    }

    private void EnableSlicerMenuItems(bool enable)
    {
      removeToolStripMenuItem.Enabled = enable;
      styleToolStripMenuItem.Enabled = enable;
      settingsToolStripMenuItem.Enabled = enable;
    }

    private void SetSlicerStyleSelected(IShape shape)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.ActiveSheet;
      foreach (ToolStripMenuItem item in styleToolStripMenuItem.DropDownItems)
        item.Checked = false;
      for (int n = 0; n < worksheet.Slicers.Count; n++)
      {
        ISlicer slicer = worksheet.Slicers[n];
        if (slicer.Shape == shape && slicer.Style.BuiltIn)
        {
          string name = slicer.Style.Name.Substring(11, slicer.Style.Name.Length - 11);
          if (styleToolStripMenuItem.DropDownItems[name] is ToolStripMenuItem item)
            item.Checked = true;
        }
      }
    }

    private void UIManager_ShapeChanged(object sender, GrapeCity.Spreadsheet.Drawing.ShapeEventArgs e)
    {
      if (e.Type == ShapeChangeType.Selection)
      {
        IShape shape = e.Shape;
        if (shape != null && shape.Type == ShapeType.Slicer && shape.Selected)
          EnableSlicerMenuItems(true);
        else
        {
          foreach (IShape s in e.Shapes)
            if (s.Type == ShapeType.Slicer)
            {
              if (s.Selected)
              {
                EnableSlicerMenuItems(true);
                SetSlicerStyleSelected(s);
                break;
              }
              else
                EnableSlicerMenuItems(false);
            }
        }
      }
    }

    private void InitStylesMenuItems()
    {
      styleToolStripMenuItem.DropDownItems.Add("Light1", Resource1.Light1, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark1;
      styleToolStripMenuItem.DropDownItems.Add("Light2", Resource1.Light2, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark2;
      styleToolStripMenuItem.DropDownItems.Add("Light3", Resource1.Light3, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark3;
      styleToolStripMenuItem.DropDownItems.Add("Light4", Resource1.Light4, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark4;
      styleToolStripMenuItem.DropDownItems.Add("Light5", Resource1.Light5, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark5;
      styleToolStripMenuItem.DropDownItems.Add("Light6", Resource1.Light6, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark6;
      styleToolStripMenuItem.DropDownItems.Add("Other1", Resource1.Other1, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleOther1;
      styleToolStripMenuItem.DropDownItems.Add("Other2", Resource1.Other2, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleOther2;
      styleToolStripMenuItem.DropDownItems.Add("Dark1", Resource1.Dark1, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark1;
      styleToolStripMenuItem.DropDownItems.Add("Dark2", Resource1.Dark2, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark2;
      styleToolStripMenuItem.DropDownItems.Add("Dark3", Resource1.Dark3, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark3;
      styleToolStripMenuItem.DropDownItems.Add("Dark4", Resource1.Dark4, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark4;
      styleToolStripMenuItem.DropDownItems.Add("Dark5", Resource1.Dark5, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark5;
      styleToolStripMenuItem.DropDownItems.Add("Dark6", Resource1.Dark6, SlicerBuiltInStyle_Click).Tag = BuiltInSlicerStyles.SlicerStyleDark6;
    }

    private void SlicerBuiltInStyle_Click(object sender, EventArgs e)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      object slicerStyle = ((ToolStripItem)sender).Tag;
      ITableStyle style = workbook.TableStyles[(BuiltInSlicerStyles)slicerStyle];
      ISlicers slicers = workbook.ActiveSheet.Slicers;
      int count = slicers.Count;
      for (int i = 0; i < count; i++)
      {
        if (slicers[i].Shape.Selected)
        {
          slicers[i].Style = style;
        }
      }
    }

    private void SettingsToolStripMenuItem_Click(object sender, EventArgs e)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.Worksheets[0];
      List<ISlicer> selectedSlicers = new List<ISlicer>();
      ISlicers slicers = workbook.ActiveSheet.Slicers;
      int count = slicers.Count;
      for (int i = 0; i < count; i++)
      {
        if (slicers[i].Shape.Selected)
        {
          selectedSlicers.Add(slicers[i]);
        }
      }
      SlicerSettingsForm form = new SlicerSettingsForm(selectedSlicers.ToArray(), workbook);
      form.ShowDialog();
    }

    private void FpSpread1_LeaveCell(object sender, LeaveCellEventArgs e)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.ActiveSheet;
      for (int iTable = 0; iTable < worksheet.Tables.Count; iTable++)
      {
        ITable table = worksheet.Tables[iTable];
        if (table.Range.Row <= e.Row && e.Row <= table.Range.Row2 && table.Range.Column <= e.Column && e.Column <= table.Range.Column2)
          addToolStripMenuItem.Enabled = false;
      }
    }

    private void FpSpread1_EnterCell(object sender, EnterCellEventArgs e)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.ActiveSheet;
      for (int iTable = 0; iTable < worksheet.Tables.Count; iTable++)
      {
        ITable table = worksheet.Tables[iTable];
        if (table.Range.Row <= e.Row && e.Row <= table.Range.Row2 && table.Range.Column <= e.Column && e.Column <= table.Range.Column2)
        {
          addToolStripMenuItem.Enabled = true;
          break;
        }
      }
    }

    private void AddToolStripMenuItem_Click(object sender, EventArgs e)
    {
      int row = fpSpread1.ActiveSheet.ActiveRowIndex;
      int column = fpSpread1.ActiveSheet.ActiveColumnIndex;
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.ActiveSheet;
      ITable table = null;

      for (int iTable = 0; iTable < worksheet.Tables.Count; iTable++)
      {
        table = worksheet.Tables[iTable];
        if (table.Range.Row <= row && row <= table.Range.Row2 && table.Range.Column <= column && column <= table.Range.Column2)
          break;
      }
      if (table == null)
        return;
      SlicerInsertForm dlg = new SlicerInsertForm(table, new Point(25, 25));
      dlg.ShowDialog(this);
    }

    private void RemoveToolStripMenuItem_Click(object sender, EventArgs e)
    {
      IWorkbook workbook = fpSpread1.AsWorkbook();
      IWorksheet worksheet = workbook.Worksheets[0];
      List<ISlicer> selectedSlicers = new List<ISlicer>();
      ISlicers slicers = workbook.ActiveSheet.Slicers;
      int count = slicers.Count;
      for (int i = 0; i < count; i++)
      {
        if (slicers[i].Shape.Selected)
        {
          selectedSlicers.Add(slicers[i]);
        }
      }
      foreach (ISlicer slicer in selectedSlicers)
        slicer.Delete();
    }
  }
}

//
//Introduction.Designer.cs
//

namespace Spread.Slicers.Features
{
  partial class Introduction
  {
    /// <summary> 
    /// Required designer variable.
    /// </summary>
    private System.ComponentModel.IContainer components = null;

    /// <summary> 
    /// Clean up any resources being used.
    /// </summary>
    /// <param name="disposing">true if managed resources should be disposed; otherwise, false.</param>
    protected override void Dispose(bool disposing)
    {
      if (disposing && (components != null))
      {
        components.Dispose();
      }
      base.Dispose(disposing);
    }

    #region Component Designer generated code

    /// <summary> 
    /// Required method for Designer support - do not modify 
    /// the contents of this method with the code editor.
    /// </summary>
    private void InitializeComponent()
    {
      System.ComponentModel.ComponentResourceManager resources = new System.ComponentModel.ComponentResourceManager(typeof(Introduction));
      this.fpSpread1 = new FarPoint.Win.Spread.FpSpread(FarPoint.Win.Spread.LegacyBehaviors.None, ((object)(resources.GetObject("pnlMain.Controls"))));
      this.fpSpread1_Sheet1 = this.fpSpread1.GetSheet(0);
      this.menuStrip1 = new System.Windows.Forms.MenuStrip();
      this.slicerToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
      this.addToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
      this.removeToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
      this.toolStripSeparator1 = new System.Windows.Forms.ToolStripSeparator();
      this.styleToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
      this.settingsToolStripMenuItem = new System.Windows.Forms.ToolStripMenuItem();
      this.pnlMain.SuspendLayout();
      ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).BeginInit();
      this.menuStrip1.SuspendLayout();
      this.SuspendLayout();
      // 
      // pnlMain
      // 
      this.pnlMain.Controls.Add(this.fpSpread1);
      this.pnlMain.Controls.Add(this.menuStrip1);
      this.pnlMain.Size = new System.Drawing.Size(600, 450);
      // 
      // pnlControls
      // 
      this.pnlControls.Size = new System.Drawing.Size(199, 450);
      // 
      // fpSpread1
      // 
      this.fpSpread1.AccessibleDescription = "fpSpread1, Sheet1, Row 0, Column 0";
      this.fpSpread1.Dock = System.Windows.Forms.DockStyle.Fill;
      this.fpSpread1.Font = new System.Drawing.Font("Calibri", 11F);
      this.fpSpread1.Location = new System.Drawing.Point(0, 24);
      this.fpSpread1.Name = "fpSpread1";
      this.fpSpread1.Size = new System.Drawing.Size(600, 426);
      this.fpSpread1.TabIndex = 0;
      this.fpSpread1.LeaveCell += new FarPoint.Win.Spread.LeaveCellEventHandler(this.FpSpread1_LeaveCell);
      this.fpSpread1.EnterCell += new FarPoint.Win.Spread.EnterCellEventHandler(this.FpSpread1_EnterCell);
      // 
      // menuStrip1
      // 
      this.menuStrip1.Items.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.slicerToolStripMenuItem});
      this.menuStrip1.Location = new System.Drawing.Point(0, 0);
      this.menuStrip1.Name = "menuStrip1";
      this.menuStrip1.Size = new System.Drawing.Size(600, 24);
      this.menuStrip1.TabIndex = 2;
      this.menuStrip1.Text = "menuStrip2";
      // 
      // slicerToolStripMenuItem
      // 
      this.slicerToolStripMenuItem.DropDownItems.AddRange(new System.Windows.Forms.ToolStripItem[] {
            this.addToolStripMenuItem,
            this.removeToolStripMenuItem,
            this.toolStripSeparator1,
            this.styleToolStripMenuItem,
            this.settingsToolStripMenuItem});
      this.slicerToolStripMenuItem.Name = "slicerToolStripMenuItem";
      this.slicerToolStripMenuItem.Size = new System.Drawing.Size(47, 20);
      this.slicerToolStripMenuItem.Text = "Slicer";
      // 
      // addToolStripMenuItem
      // 
      this.addToolStripMenuItem.Name = "addToolStripMenuItem";
      this.addToolStripMenuItem.Size = new System.Drawing.Size(125, 22);
      this.addToolStripMenuItem.Text = "Insert...";
      this.addToolStripMenuItem.Click += new System.EventHandler(this.AddToolStripMenuItem_Click);
      // 
      // removeToolStripMenuItem
      // 
      this.removeToolStripMenuItem.Name = "removeToolStripMenuItem";
      this.removeToolStripMenuItem.Size = new System.Drawing.Size(125, 22);
      this.removeToolStripMenuItem.Text = "Remove";
      this.removeToolStripMenuItem.Click += new System.EventHandler(this.RemoveToolStripMenuItem_Click);
      // 
      // toolStripSeparator1
      // 
      this.toolStripSeparator1.Name = "toolStripSeparator1";
      this.toolStripSeparator1.Size = new System.Drawing.Size(122, 6);
      // 
      // styleToolStripMenuItem
      // 
      this.styleToolStripMenuItem.Name = "styleToolStripMenuItem";
      this.styleToolStripMenuItem.Size = new System.Drawing.Size(125, 22);
      this.styleToolStripMenuItem.Text = "Style";
      // 
      // settingsToolStripMenuItem
      // 
      this.settingsToolStripMenuItem.Name = "settingsToolStripMenuItem";
      this.settingsToolStripMenuItem.Size = new System.Drawing.Size(125, 22);
      this.settingsToolStripMenuItem.Text = "Settings...";
      this.settingsToolStripMenuItem.Click += new System.EventHandler(this.SettingsToolStripMenuItem_Click);
      // 
      // SlicerIntro
      // 
      this.AutoScaleDimensions = new System.Drawing.SizeF(6F, 13F);
      this.AutoScaleMode = System.Windows.Forms.AutoScaleMode.Font;
      this.Name = "Introduction";
      this.Size = new System.Drawing.Size(800, 450);
      this.pnlMain.ResumeLayout(false);
      this.pnlMain.PerformLayout();
      ((System.ComponentModel.ISupportInitialize)(this.fpSpread1)).EndInit();
      this.menuStrip1.ResumeLayout(false);
      this.menuStrip1.PerformLayout();
      this.ResumeLayout(false);

    }

    #endregion

    private FarPoint.Win.Spread.FpSpread fpSpread1;
    private FarPoint.Win.Spread.SheetView fpSpread1_Sheet1;
    private System.Windows.Forms.MenuStrip menuStrip1;
    private System.Windows.Forms.ToolStripMenuItem slicerToolStripMenuItem;
    private System.Windows.Forms.ToolStripMenuItem addToolStripMenuItem;
    private System.Windows.Forms.ToolStripMenuItem removeToolStripMenuItem;
    private System.Windows.Forms.ToolStripSeparator toolStripSeparator1;
    private System.Windows.Forms.ToolStripMenuItem styleToolStripMenuItem;
    private System.Windows.Forms.ToolStripMenuItem settingsToolStripMenuItem;
  }
}
